Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2968
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.4 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`monetary` is highly overall correlated with `qtd_compras` and 3 other fields	High correlation
`qtd_compras` is highly overall correlated with `monetary` and 3 other fields	High correlation
`qtd_items` is highly overall correlated with `monetary` and 3 other fields	High correlation
`qtd_prods` is highly overall correlated with `monetary` and 3 other fields	High correlation
`recency` is highly overall correlated with `qtd_compras`	High correlation
`avg_ticket` is highly overall correlated with `unique_avg_basket`	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`unique_avg_basket` is highly overall correlated with `qtd_prods` and 1 other fields	High correlation
`avg_basket` is highly overall correlated with `monetary` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 25.1569664)	Skewed
`frequency` is highly skewed (γ1 = 24.87687084)	Skewed
`qtd_returns` is highly skewed (γ1 = 21.9754032)	Skewed
`customer_id` has unique values	Unique
`recency` has 33 (1.1%) zeros	Zeros
`qtd_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2023-06-12 18:29:58.152200
Analysis finished	2023-06-12 18:30:16.018943
Duration	17.87 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	2968
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.377

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.35
Q1	13798.75
median	15220.5
Q3	16768.5
95-th percentile	17964.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.1445
Coefficient of variation (CV)	0.11258036
Kurtosis	-1.2061782
Mean	15270.377
Median Absolute Deviation (MAD)	1489
Skewness	0.032193711
Sum	45322479
Variance	2955457.9
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12347	1	< 0.1%
16258	1	< 0.1%
16242	1	< 0.1%
16243	1	< 0.1%
16244	1	< 0.1%
16245	1	< 0.1%
16249	1	< 0.1%
16250	1	< 0.1%
16253	1	< 0.1%
16255	1	< 0.1%
Other values (2958)	2958	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

monetary
Real number (ℝ)

Distinct	2953
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2693.4851

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.7325
Q1	570.845
median	1085.51
Q3	2306.905
95-th percentile	7169.562
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1736.06

Descriptive statistics

Standard deviation	10135.465
Coefficient of variation (CV)	3.7629558
Kurtosis	397.30132
Mean	2693.4851
Median Absolute Deviation (MAD)	670.84
Skewness	17.635372
Sum	7994263.7
Variance	1.0272766 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
889.93	2	0.1%
1353.74	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
745.06	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
178.96	2	0.1%
331	2	0.1%
734.94	2	0.1%
Other values (2943)	2948	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

qtd_compras
Real number (ℝ)

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7243935

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8577599
Coefficient of variation (CV)	1.5473709
Kurtosis	190.78624
Mean	5.7243935
Median Absolute Deviation (MAD)	2
Skewness	10.765555
Sum	16990
Variance	78.45991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	784	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	784	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtd_items
Real number (ℝ)

Distinct	1670
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1582.1044

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	102.35
Q1	296
median	640
Q3	1399.5
95-th percentile	4403.25
Maximum	196844
Range	196843
Interquartile range (IQR)	1103.5

Descriptive statistics

Standard deviation	5705.2914
Coefficient of variation (CV)	3.6061408
Kurtosis	516.7418
Mean	1582.1044
Median Absolute Deviation (MAD)	421
Skewness	18.737654
Sum	4695686
Variance	32550350
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
246	8	0.3%
288	8	0.3%
260	8	0.3%
84	8	0.3%
272	8	0.3%
200	7	0.2%
394	7	0.2%
Other values (1660)	2885	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

qtd_prods
Real number (ℝ)

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.76449

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.93294
Coefficient of variation (CV)	2.1987868
Kurtosis	354.77884
Mean	122.76449
Median Absolute Deviation (MAD)	44
Skewness	15.706135
Sum	364365
Variance	72863.79
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
29	35	1.2%
35	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2628	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	15	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

recency
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.309299

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.760922
Coefficient of variation (CV)	1.2091707
Kurtosis	2.7765172
Mean	64.309299
Median Absolute Deviation (MAD)	26
Skewness	1.7980529
Sum	190870
Variance	6046.7611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2218	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2965
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.994257

Minimum	2.1505882
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.915888
Q1	13.118111
median	17.953447
Q3	24.981794
95-th percentile	90.052125
Maximum	4453.43
Range	4451.2794
Interquartile range (IQR)	11.863683

Descriptive statistics

Standard deviation	119.53207
Coefficient of variation (CV)	3.6228143
Kurtosis	812.96474
Mean	32.994257
Median Absolute Deviation (MAD)	5.9790186
Skewness	25.156966
Sum	97926.954
Variance	14287.915
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
15	2	0.1%
23.68131868	1	< 0.1%
57.87923077	1	< 0.1%
12.25581633	1	< 0.1%
8.021568627	1	< 0.1%
16.73351648	1	< 0.1%
15.70733333	1	< 0.1%
26.08797101	1	< 0.1%
Other values (2955)	2955	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ)

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.302133

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.917308
median	48.267857
Q3	85.333333
95-th percentile	200.65
Maximum	366
Range	365
Interquartile range (IQR)	59.416026

Descriptive statistics

Standard deviation	63.505358
Coefficient of variation (CV)	0.94358612
Kurtosis	4.9080488
Mean	67.302133
Median Absolute Deviation (MAD)	26.267857
Skewness	2.066084
Sum	199752.73
Variance	4032.9306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
11	17	0.6%
46	17	0.6%
21	17	0.6%
28	16	0.5%
Other values (1248)	2776	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11383237

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088935048
Q1	0.016339869
median	0.025898352
Q3	0.049478583
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.033138713

Descriptive statistics

Standard deviation	0.40822056
Coefficient of variation (CV)	3.5861552
Kurtosis	989.06632
Mean	0.11383237
Median Absolute Deviation (MAD)	0.012196886
Skewness	24.876871
Sum	337.85449
Variance	0.16664402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.5%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.07692307692	13	0.4%
0.03571428571	13	0.4%
Other values (1215)	2635	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtd_returns
Real number (ℝ)

SKEWED ZEROS

Distinct	213
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.888477

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	282.86478
Coefficient of variation (CV)	8.107685
Kurtosis	596.20199
Mean	34.888477
Median Absolute Deviation (MAD)	1
Skewness	21.975403
Sum	103549
Variance	80012.486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
8	43	1.4%
7	43	1.4%
Other values (203)	705	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

unique_avg_basket
Real number (ℝ)

Distinct	906
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.489977

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.6666667
median	13.6
Q3	22.144643
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.477976

Descriptive statistics

Standard deviation	15.460127
Coefficient of variation (CV)	0.88394209
Kurtosis	29.324685
Mean	17.489977
Median Absolute Deviation (MAD)	6.6
Skewness	3.4364678
Sum	51910.252
Variance	239.01552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	42	1.4%
9	41	1.4%
8	39	1.3%
16	39	1.3%
17	38	1.3%
14	38	1.3%
7	36	1.2%
11	36	1.2%
5	36	1.2%
15	35	1.2%
Other values (896)	2588	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

avg_basket
Real number (ℝ)

Distinct	1978
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.25289

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2375
median	172.29167
Q3	281.54808
95-th percentile	599.58
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	178.31058

Descriptive statistics

Standard deviation	283.8932
Coefficient of variation (CV)	1.2016496
Kurtosis	102.78169
Mean	236.25289
Median Absolute Deviation (MAD)	83.041667
Skewness	7.7018777
Sum	701198.57
Variance	80595.347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
86	9	0.3%
82	9	0.3%
73	9	0.3%
136	8	0.3%
60	8	0.3%
75	8	0.3%
88	8	0.3%
197	7	0.2%
Other values (1968)	2881	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

Auto

Heatmap
Table

	customer_id	monetary	qtd_compras	qtd_items	qtd_prods	recency	avg_ticket	avg_recency_days	frequency	qtd_returns	unique_avg_basket	avg_basket
customer_id	1.000	-0.077	0.026	-0.071	0.013	0.001	-0.131	0.019	-0.002	-0.064	-0.016	-0.123
monetary	-0.077	1.000	0.772	0.925	0.746	-0.414	0.245	-0.249	0.091	0.371	0.106	0.574
qtd_compras	0.026	0.772	1.000	0.718	0.690	-0.503	0.060	-0.258	0.078	0.295	-0.181	0.101
qtd_items	-0.071	0.925	0.718	1.000	0.732	-0.407	0.166	-0.228	0.081	0.343	0.148	0.729
qtd_prods	0.013	0.746	0.690	0.732	1.000	-0.436	-0.377	-0.165	0.035	0.244	0.515	0.384
recency	0.001	-0.414	-0.503	-0.407	-0.436	1.000	0.049	0.109	0.017	-0.119	0.014	-0.097
avg_ticket	-0.131	0.245	0.060	0.166	-0.377	0.049	1.000	-0.123	0.091	0.189	-0.618	0.187
avg_recency_days	0.019	-0.249	-0.258	-0.228	-0.165	0.109	-0.123	1.000	-0.881	-0.398	0.131	-0.078
frequency	-0.002	0.091	0.078	0.081	0.035	0.017	0.091	-0.881	1.000	0.235	-0.122	0.028
qtd_returns	-0.064	0.371	0.295	0.343	0.244	-0.119	0.189	-0.398	0.235	1.000	-0.053	0.209
unique_avg_basket	-0.016	0.106	-0.181	0.148	0.515	0.014	-0.618	0.131	-0.122	-0.053	1.000	0.404
avg_basket	-0.123	0.574	0.101	0.729	0.384	-0.097	0.187	-0.078	0.028	0.209	0.404	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	monetary	qtd_compras	qtd_items	qtd_prods	recency	avg_ticket	avg_recency_days	frequency	qtd_returns	unique_avg_basket	avg_basket
1	12347.0	4310.00	7	2458	182	2	23.681319	60.833333	0.019126	0.0	14.714286	351.142857
2	12348.0	1437.24	4	2332	27	75	53.231111	94.333333	0.014085	0.0	5.250000	583.000000
5	12352.0	1385.74	7	526	77	36	17.996623	43.333333	0.026820	63.0	8.142857	75.142857
9	12356.0	2487.43	3	1573	58	22	42.886724	151.500000	0.009868	0.0	17.333333	524.333333
11	12358.0	928.06	2	242	17	1	54.591765	149.000000	0.013333	0.0	6.000000	121.000000
12	12359.0	6372.58	4	1622	248	57	25.695887	64.800000	0.014545	10.0	53.500000	405.500000
13	12360.0	2302.06	3	1156	126	52	18.270317	74.000000	0.020134	0.0	34.666667	385.333333
15	12362.0	4737.23	10	2197	256	3	18.504805	24.333333	0.034130	17.0	20.000000	219.700000
16	12364.0	1208.10	4	1499	81	7	14.914815	35.000000	0.037736	0.0	17.250000	374.750000
19	12370.0	3425.69	4	2350	166	51	20.636687	103.000000	0.012903	0.0	35.500000	587.500000

	customer_id	monetary	qtd_compras	qtd_items	qtd_prods	recency	avg_ticket	avg_recency_days	frequency	qtd_returns	unique_avg_basket	avg_basket
4316	18269.0	168.60	1	76	7	366	24.085714	8.000000	1.000000	6.0	7.000000	76.000000
4317	18270.0	283.15	2	101	11	38	25.740909	114.000000	0.008734	3.0	5.500000	50.500000
4318	18272.0	3078.58	6	2050	166	2	18.545663	40.666667	0.024490	6.0	16.500000	341.666667
4319	18273.0	204.00	3	80	3	2	68.000000	127.500000	0.011719	0.0	0.333333	26.666667
4320	18274.0	175.92	1	88	11	30	15.992727	13.000000	1.000000	88.0	11.000000	88.000000
4321	18276.0	335.86	1	186	14	43	23.990000	22.000000	1.000000	2.0	14.000000	186.000000
4322	18277.0	110.38	1	68	8	58	13.797500	260.000000	1.000000	1.0	8.000000	68.000000
4326	18282.0	178.05	2	103	12	7	14.837500	59.500000	0.016667	5.0	6.000000	51.500000
4327	18283.0	2088.93	16	1395	754	3	2.770464	25.692308	0.047761	0.0	16.375000	87.187500
4328	18287.0	1837.28	3	1586	70	42	26.246857	79.500000	0.018750	0.0	19.666667	528.666667

Overview

Variables

Interactions

Correlations

Missing values

Sample